/ Gigarom 4 / Mac Giga-ROM 4.0 - 1993.toast / FILES / DEM / I-M / MSFileDemo / File.Help.rsrc / HELP_9_Computed Fields

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 21 00 00 00 42 00 60 | 00 60 00 9b 00 d4 01 10 |.!...B.`|.`......|
|00000010| 01 42 01 42 01 7f 01 ba | 01 f8 02 29 02 29 02 6c |.B.B....|...).).l|
|00000020| 02 a8 02 d7 02 d7 02 e1 | 02 f0 02 ff 03 0c 03 2b |........|.......+|
|00000030| 03 2b 03 69 03 a9 03 e8 | 04 25 04 63 04 a1 04 a1 |.+.i....|.%.c....|
|00000040| 04 dc 05 15 05 54 41 20 | 63 6f 6d 70 75 74 65 64 |.....TA |computed|
|00000050| 20 66 69 65 6c 64 20 69 | 73 20 61 20 4e 75 6d 62 | field i|s a Numb|
|00000060| 65 72 20 66 69 65 6c 64 | 20 6f 72 20 44 61 74 65 |er field| or Date|
|00000070| 20 66 69 65 6c 64 20 74 | 68 61 74 20 64 69 73 70 | field t|hat disp|
|00000080| 6c 61 79 73 20 74 68 65 | 72 65 73 75 6c 74 20 6f |lays the|result o|
|00000090| 66 20 61 20 66 6f 72 6d | 75 6c 61 20 79 6f 75 20 |f a form|ula you |
|000000a0| 77 72 69 74 65 2e 7e 53 | 01 54 6f 20 63 72 65 61 |write.~S|.To crea|
|000000b0| 74 65 20 61 20 63 6f 6d | 70 75 74 65 64 20 44 61 |te a com|puted Da|
|000000c0| 74 65 20 66 69 65 6c 64 | 3a 7e 53 00 20 20 54 79 |te field|:~S.  Ty|
|000000d0| 70 65 20 61 20 6e 61 6d | 65 20 66 6f 72 20 74 68 |pe a nam|e for th|
|000000e0| 65 66 69 65 6c 64 2c 20 | 74 68 65 6e 20 63 68 6f |efield, |then cho|
|000000f0| 6f 73 65 20 74 68 65 20 | 46 6f 72 6d 61 74 20 44 |ose the |Format D|
|00000100| 61 74 65 20 46 69 65 6c | 64 20 63 6f 6d 6d 61 6e |ate Fiel|d comman|
|00000110| 64 20 66 72 6f 6d 20 74 | 68 65 46 6f 72 6d 20 6d |d from t|heForm m|
|00000120| 65 6e 75 2e 20 20 43 68 | 6f 6f 73 65 20 44 61 74 |enu.  Ch|oose Dat|
|00000130| 65 20 61 73 20 74 68 65 | 20 69 6e 66 6f 72 6d 61 |e as the| informa|
|00000140| 74 69 6f 6e 20 74 79 70 | 65 2c 20 74 68 65 6e 20 |tion typ|e, then |
|00000150| 63 68 6f 6f 73 65 43 6f | 6d 70 75 74 65 64 2c 20 |chooseCo|mputed, |
|00000160| 61 6e 64 20 74 79 70 65 | 20 74 68 65 20 66 6f 72 |and type| the for|
|00000170| 6d 75 6c 61 20 69 6e 20 | 74 68 65 20 46 6f 72 6d |mula in |the Form|
|00000180| 75 6c 61 20 62 6f 78 2e | 7e 53 01 54 6f 20 63 72 |ula box.|~S.To cr|
|00000190| 65 61 74 65 20 61 20 63 | 6f 6d 70 75 74 65 64 20 |eate a c|omputed |
|000001a0| 4e 75 6d 62 65 72 20 66 | 69 65 6c 64 3a 7e 53 00 |Number f|ield:~S.|
|000001b0| 20 20 54 79 70 65 20 61 | 20 6e 61 6d 65 20 66 6f |  Type a| name fo|
|000001c0| 72 20 74 68 65 66 69 65 | 6c 64 2c 20 74 68 65 6e |r thefie|ld, then|
|000001d0| 20 63 68 6f 6f 73 65 20 | 74 68 65 20 46 6f 72 6d | choose |the Form|
|000001e0| 61 74 20 4e 75 6d 62 65 | 72 20 46 69 65 6c 64 20 |at Numbe|r Field |
|000001f0| 63 6f 6d 6d 61 6e 64 20 | 66 72 6f 6d 20 74 68 65 |command |from the|
|00000200| 46 6f 72 6d 20 6d 65 6e | 75 2e 20 20 43 68 6f 6f |Form men|u.  Choo|
|00000210| 73 65 20 4e 75 6d 62 65 | 72 20 61 73 20 74 68 65 |se Numbe|r as the|
|00000220| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 74 79 70 | informa|tion typ|
|00000230| 65 2c 20 74 68 65 6e 20 | 63 68 6f 6f 73 65 43 6f |e, then |chooseCo|
|00000240| 6d 70 75 74 65 64 20 61 | 6e 64 20 74 79 70 65 20 |mputed a|nd type |
|00000250| 74 68 65 20 66 6f 72 6d | 75 6c 61 20 69 6e 20 74 |the form|ula in t|
|00000260| 68 65 20 46 6f 72 6d 75 | 6c 61 20 62 6f 78 2e 7e |he Formu|la box.~|
|00000270| 53 01 54 6f 20 77 72 69 | 74 65 20 61 20 66 6f 72 |S.To wri|te a for|
|00000280| 6d 75 6c 61 3a 7e 53 00 | 20 20 53 65 6c 65 63 74 |mula:~S.|  Select|
|00000290| 20 61 6e 20 69 6e 73 65 | 72 74 69 6f 6e 20 70 6f | an inse|rtion po|
|000002a0| 69 6e 74 20 69 6e 20 74 | 68 65 20 66 6f 72 6d 75 |int in t|he formu|
|000002b0| 6c 61 74 65 78 74 20 62 | 6f 78 2c 20 61 6e 64 20 |latext b|ox, and |
|000002c0| 74 68 65 6e 20 75 73 65 | 20 74 68 65 73 65 20 73 |then use| these s|
|000002d0| 79 6d 62 6f 6c 73 20 61 | 6c 6f 6e 67 20 77 69 74 |ymbols a|long wit|
|000002e0| 68 20 6e 61 6d 65 73 20 | 6f 66 20 61 6e 79 6f 74 |h names |of anyot|
|000002f0| 68 65 72 20 66 69 65 6c | 64 73 20 79 6f 75 20 77 |her fiel|ds you w|
|00000300| 61 6e 74 20 69 6e 63 6c | 75 64 65 64 20 69 6e 20 |ant incl|uded in |
|00000310| 79 6f 75 72 20 66 6f 72 | 6d 75 6c 61 3a 7e 54 02 |your for|mula:~T.|
|00000320| 2b 7e 54 01 41 64 64 7e | 54 02 2d 7e 54 01 53 75 |+~T.Add~|T.-~T.Su|
|00000330| 62 74 72 61 63 74 7e 54 | 02 2a 7e 54 01 4d 75 6c |btract~T|.*~T.Mul|
|00000340| 74 69 70 6c 79 7e 54 02 | 2f 7e 54 01 44 69 76 69 |tiply~T.|/~T.Divi|
|00000350| 64 65 7e 54 02 28 20 29 | 20 7e 54 01 54 6f 20 63 |de~T.( )| ~T.To c|
|00000360| 6f 6d 62 69 6e 65 20 6f | 70 65 72 61 74 69 6f 6e |ombine o|peration|
|00000370| 73 46 6f 72 20 65 78 61 | 6d 70 6c 65 2c 20 74 79 |sFor exa|mple, ty|
|00000380| 70 65 7e 53 02 74 6f 74 | 61 6c 20 73 61 6c 65 73 |pe~S.tot|al sales|
|00000390| 20 2a 20 2e 30 33 7e 53 | 00 20 20 74 6f 20 63 6f | * .03~S|.  to co|
|000003a0| 6d 70 75 74 65 20 33 20 | 70 65 72 63 65 6e 74 6f |mpute 3 |percento|
|000003b0| 66 20 74 6f 74 61 6c 20 | 73 61 6c 65 73 2e 20 20 |f total |sales.  |
|000003c0| 49 6e 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 2c 20 |In the f|ormula, |
|000003d0| 79 6f 75 20 63 61 6e 20 | 72 65 66 65 72 20 6f 6e |you can |refer on|
|000003e0| 6c 79 20 74 6f 20 4e 75 | 6d 62 65 72 20 6f 72 44 |ly to Nu|mber orD|
|000003f0| 61 74 65 20 66 69 65 6c | 64 73 20 61 6e 64 20 63 |ate fiel|ds and c|
|00000400| 61 6e 6e 6f 74 20 6d 61 | 6b 65 20 74 68 65 20 63 |annot ma|ke the c|
|00000410| 6f 6d 70 75 74 65 64 20 | 66 69 65 6c 64 20 72 65 |omputed |field re|
|00000420| 66 65 72 20 74 6f 20 69 | 74 73 65 6c 66 2c 6e 6f |fer to i|tself,no|
|00000430| 72 20 74 6f 20 61 6e 79 | 20 66 69 65 6c 64 20 74 |r to any| field t|
|00000440| 68 61 74 20 65 76 65 6e | 74 75 61 6c 6c 79 20 72 |hat even|tually r|
|00000450| 65 66 65 72 73 20 62 61 | 63 6b 20 74 6f 20 74 68 |efers ba|ck to th|
|00000460| 61 74 20 63 6f 6d 70 75 | 74 65 64 66 69 65 6c 64 |at compu|tedfield|
|00000470| 2e 20 20 49 66 20 79 6f | 75 20 72 65 66 65 72 20 |.  If yo|u refer |
|00000480| 74 6f 20 61 20 66 69 65 | 6c 64 20 79 6f 75 20 68 |to a fie|ld you h|
|00000490| 61 76 65 20 6e 6f 74 20 | 79 65 74 20 63 72 65 61 |ave not |yet crea|
|000004a0| 74 65 64 2c 20 46 69 6c | 65 64 69 73 70 6c 61 79 |ted, Fil|edisplay|
|000004b0| 73 20 23 45 52 52 4f 52 | 21 20 69 6e 20 74 68 65 |s #ERROR|! in the|
|000004c0| 20 63 6f 6d 70 75 74 65 | 64 20 66 69 65 6c 64 20 | compute|d field |
|000004d0| 69 6e 20 74 68 65 20 64 | 61 74 61 66 69 6c 65 20 |in the d|atafile |
|000004e0| 77 69 6e 64 6f 77 2e 42 | 65 20 73 75 72 65 20 74 |window.B|e sure t|
|000004f0| 6f 20 66 6f 72 6d 61 74 | 20 61 20 66 69 65 6c 64 |o format| a field|
|00000500| 20 61 73 20 63 6f 6d 70 | 75 74 65 64 20 77 68 65 | as comp|uted whe|
|00000510| 6e 20 79 6f 75 20 66 69 | 72 73 74 20 63 72 65 61 |n you fi|rst crea|
|00000520| 74 65 74 68 65 20 66 6f | 72 6d 2e 20 20 49 66 20 |tethe fo|rm.  If |
|00000530| 79 6f 75 20 71 75 69 74 | 20 46 69 6c 65 2c 20 61 |you quit| File, a|
|00000540| 64 64 20 72 65 63 6f 72 | 64 73 2c 20 6f 72 20 6f |dd recor|ds, or o|
|00000550| 70 65 6e 20 61 6e 6f 74 | 68 65 72 64 61 74 61 66 |pen anot|herdataf|
|00000560| 69 6c 65 2c 20 79 6f 75 | 20 77 69 6c 6c 20 6e 6f |ile, you| will no|
|00000570| 74 20 62 65 20 61 62 6c | 65 20 74 6f 20 66 6f 72 |t be abl|e to for|
|00000580| 6d 61 74 20 74 68 65 20 | 66 69 65 6c 64 20 61 73 |mat the |field as|
|00000590| 20 63 6f 6d 70 75 74 65 | 64 2e                   | compute|d.      |
+--------+-------------------------+-------------------------+--------+--------+